How to convert QlikView Time to Salesforce time in a load script?

December 14, 2009, 3:55 pm by Rhyous

Ok, so here is what I am doing:

I am getting the QVD file date using:

Let QVDPath='C:\ProgramData\QlikTech\QVD';
Let ThisExecTime = Reloadtime();
Let LastExecTime = QvdCreateTime('$(QVDPath)\SFCase.qvd');

I am trying to only get data modified since load using WHERE LastModifiedDate > $(LastExecTime ).

According to salesforce, the time stamp should be in this format:

1999-01-01T23:01:01Z

So I created this sub to get Salesforce time from QlikView time:

Sub SFTime(inDateTime)
    Let inDateTime=date(inDateTime, 'YYYY-MM-DD') & 'T' & time(inDateTime, 'HH:MM:SS') & 'Z';
EndSub

It works.

Category: QlikView | Comment (RSS) | Trackback

Rhyous